Release 10.1A: OpenEdge Data Management:
SQL Reference

AUDIT SET

Allows grouping of audit data by the client on a per-connection basis.

For more information about auditing, see OpenEdge Getting Started: Core Business Services . For more information about enabling a database for auditing, see OpenEdge Data Management: Database Administration .

Syntax

AUDIT SET [ EVENT_GROUP | APPLICATION_CONTEXT ] [ string | NULL ];

EVENT_GROUP

Indicates that subsequent audit records written by the database engine during the current connection will be marked as part of an event group.

APPLICATION_CONTEXT

Indicates that subsequent audit records written by the database engine during the current connection will be saved with application context information.

string

Free-form character value that qualifies the event group or application context.

NULL

Clears an event group or application context string.

Examples

In this example, an application context is set:

AUDIT SET APPLICATION_CONTEXT ’06/02/2005 Deposits’;

In this example, the application context is cleared:

AUDIT SET APPLICATION_CONTEXT NULL;

Note

AUDIT SET always returns a success status. This prevents users from determining whether or not they have audit privileges.

Authorization

Must have AUDIT_ADMIN, AUDIT_ARCHIVE, or AUDIT_INSERT privileges.